import xlrd,sys

class Readxls:
    def __init__(self):
        self.file=r'data/woniuboss.xls'
        self.list = []
    def readxls(self):
        wb = xlrd.open_workbook(self.file)
        mysheet=wb.sheet_by_name('Sheet1')
        for i in range(mysheet.nrows):
            r_values = mysheet.row_values(i)
            if i!=0:
                a = dict(zip(mysheet.row_values(0), r_values))
                self.list.append(a)
        return self.list


if __name__ == '__main__':
    print(Readxls().readxls())
